USE [DocsRoomManagement]
GO

SELECT [Id]
      ,[Name]
  FROM [dbo].[City]
GO


/*********add foreign key *********/
ALTER TABLE City
  ADD CONSTRAINT FK_City_ZipCode
    FOREIGN KEY(ZipCodeId) REFERENCES Zip_Code(Id)


/*********add Column to table *********/

  ALTER TABLE City
  ADD ZipCodeId int;

  /*********create Tables with composite keys *********/
  create table Street_Map_City (
     StreetId int not null,
     CityId int not null,
     primary key (StreetId, CityId)
);










